package cn.tedu.dfxd.mapper;

import cn.tedu.dfxd.entity.Item;
import cn.tedu.dfxd.entity.UserRole;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author DBX
 * @effect
 * @date 2022/04/22/13:06
 */
public interface UserRoleMapper  extends BaseMapper<UserRole> {
    @Select("select role_id from user_role where id = #{id} ")
    Integer findRoleId(Integer id);

    @Select("select id from user_role where role_id = 1 order by id desc limit 0,3")
    List<Integer> contact();
}
